package com.jrzh.db.migration.sys;

import com.jrzh.framework.migration.BaseMigration;
import com.jrzh.framework.migration.MigrationHelper;

public class Migration_23 extends BaseMigration{

	private static final String TABLE_NAME = "sys_message_channels";
	
	@Override
	public void down() {
		MigrationHelper.dropTable(TABLE_NAME);
	}

	@Override
	public void up() {
		log.info("##########执行Sys模块 Migration_23##########Begin");
		table(TABLE_NAME, "系统消息通道表", true, 
				pk(),
				jrVarchar("_code", "通道编号", 64),
				jrVarchar("_module", "所属模块", 64),
				jrVarchar("_type", "通道类型", 64),
				jrVarchar("_recive_id", "接收id", 36),
				jrVarchar("_send_id", "发送id", 36),
				jrText("_data", "消息内容（JSON格式字符串）"),
				jrText("_expand_data", "扩展信息内容（JSON格式字符串）")
		);
		log.info("##########执行Sys模块 Migration_23##########End");
	}

}
